Analyzing Healthcare Provider Shortage - Part 3/4¶
In this part of the study, we will explore shortage of Mental Healthcare Providers and OB-GYN Providers. We will study the distribution of:
- Providers across all states to identify which states have the most shortage and
- for those states study shortage at the county level to understand which counties are suffering the most
In this section, we will:
- Explore Mental Healthcare Providers
- Study how Mental Healthcare Providers vary by Population Density accross all states
- Identify state with highest people to provider ratio
- Explore the state with highest ratio to understand how providers vary across different counties for that state
- Explore OBGYN Healthcare Providers
- Study how OBGYN Healthcare Providers vary by population of mothers accross all states
- Identify state with highest mothers to provider ratio
- Explore the state with highest ratio to understand how providers vary across different counties for that state
Table of Contents
- 1 Analyzing Healthcare Provider Shortage - Part 3/4
- 2 Part 3: Provider Shortage - Mental Health and OB-GYN Providers
Part 3: Provider Shortage - Mental Health and OB-GYN Providers¶
In [1]:
# Import Libraries
from IPython.display import display
# Import arcgis
import arcgis
from arcgis.gis import GIS
from arcgis.features import FeatureLayer
from arcgis.mapping import WebMap
# Import libraries for data exploration
import pandas as pd
pd.set_option('display.max_columns', 500)
import numpy as np
# Import plotting libraries
%matplotlib inline
import matplotlib.pyplot as plt
import seaborn as sns
# Import library for time
import time
In [2]:
# Create a GIS connection
gis = GIS("https://datascienceqa.esri.com/portal", "portaladmin", "esri.agp", verify_cert=False)
# gis = GIS("https://datascienceqa.esri.com/portal", "portaladmin", "esri.agp")
Get Data Layers¶
Provider data was geocoded using the GeoAnalytics server. We will get the geocoded provider data feature layer. We will also get demographic data from the 2018 USA Population Density layer.
Get Provider Data¶
In [3]:
# Search the feature layer
search_result = gis.content.search('title: provider_data_geocoded_7_30', 'Feature Layer')
search_result
Out[3]:
In [4]:
# Get the feature layer item
provider_data_item = search_result[0]
provider_data_item
Out[4]:
Feature Layer Collection by portaladmin
In [5]:
# Check for layers inside the item
provider_data_item.layers
Out[5]:
In [6]:
# Get the layer needed for analysis
provider_data_layer = provider_data_item.layers[0]
provider_data_layer
Out[6]:
In [7]:
# Look at the first 5 fields and their data types
for f in provider_data_layer.properties.fields[:5]:
print(f['name'],' ',f['type'])
Get Demographics Data¶
In [8]:
# Search for Population data layer
popsearch_result = gis.content.search('title: 2018 USA Population Density')
popsearch_result
Out[8]:
In [9]:
# Get Population Density
popdensity = popsearch_result[0]
popdensity
Out[9]:
Map Image Layer by esri_livingatlas
In [10]:
# Check first 5 layers in population Density
popdensity.layers[:5]
Out[10]:
In [11]:
# Look at first few field names for county layer
county_layer = popdensity.layers[46]
print('FIELD NAME', '\t\t', 'FIELD ALIAS')
for field in county_layer.properties.fields[:10]:
print(field['name'], '\t\t', field['alias'])
In [9]:
# Get specific attributes for Counties
%time
county_layer = popdensity.layers[46]
county_df = pd.DataFrame()
offset = 0
while offset <= 3000:
chunk_df = county_layer.query(out_fields=['Shape','ST_ABBREV','NAME','ASIAN_CY','AMERIND_CY','AVGHHSZ_CY','AVGHINC_CY','BLACK_CY','EDUCBASECY','HISPPOP_CY',
'MEDAGE_CY','MINORITYCY','OTHRACE_CY','PCI_CY','POPDENS_CY','UNEMPRT_CY','WHITE_CY','SMCOLL_CY',
'ASSCDEG_CY','BACHDEG_CY','GRADDEG_CY','TOTPOP_CY'],return_all_records=False,result_offset=offset,result_record_count=750,as_df=True)
county_df = pd.concat([chunk_df, county_df], ignore_index=True)
offset += 750
In [10]:
county_df.shape
Out[10]:
Mental Health¶
Image source: https://cuindependent.com/2019/03/08/opinion-mental-health-education/
- Nearly one in five people in the U.S. have some sort of mental health condition.
- Adults living with serious mental illness die on average 25 years earlier than others.
- Suicide is the 2nd leading cause of death for people aged 10–34.
Mental Healthcare Providers - Heat Map¶
Let's explore the distribution of mental health providers in US using a heatmap.
In [24]:
# Create a map
mental_map = gis.map('USA', 4)
mental_map
In [27]:
# Add provider data to map
renderer = {"renderer": "autocast", #This tells python to use JS autocasting
"type": "heatmap",
"blurRadius":1, # changes the size of the clusters
"maxPixelIntensity":2,
"minPixelIntensity":0,
"field":None}
renderer["colorStops"] = [{"ratio":0,"color":[63, 40, 102, 0]},
{"ratio":0.25,"color":[167,97,170,179]},
{"ratio":0.50,"color":"#7b3ce9"},
{"ratio":0.75,"color":[222,102,0,179]},
{"ratio":1,"color":[244,204,0,179]}]
mental_map.add_layer(provider_data_layer,
{ "type": "FeatureLayer",
"renderer": renderer,
"definition_expression" : "user_taxonomy_code_1 in ('2084P0800X','207QG0300X','273R00000X','103T00000X','103TA0400X','103TA0700X','103TC0700X','103TC2200X','103TB0200X','103TC1900X','103TE1000X','103TE1100X','103TF0000X','103TF0200X','103TP2701X','103TH0004X','103TH0100X','103TM1700X','103TM1800X','103TP0016X','103TP0814X','103TP2700X','103TR0400X','103TS0200X','103TW0100X','106E00000X','106S00000X','2084A0401X','2084P0802X','2084B0002X','2084P0804X','2084N0600X','2084D0003X','2084F0202X','2084P0805X','2084H0002X','2084P0005X','2084N0400X','2084N0402X','2084N0008X','2084P2900X','2084P0015X','2084S0012X','2084S0010X','2084V0102X','364SP0808X','364SP0809X','364SP0807X','364SP0810X','364SP0811X','364SP0812X','364SP0813X','283Q00000X','261QM0801X')"
})
In [28]:
mental_map.remove_layers()
Out[28]:
In [77]:
mental_map.take_screenshot()
This map paints a grim picture of the availability of mental healthcare providers. There are states in every region with vast areas of NO mental health providers or very few providers. To list, some of these states include:
- Midwest: The Dakotas, Montana, Wyoming, Colorado, Nebraska, Kansas
- South: Texas, New Mexico, Kansas, Louisiana, Mississippi, Alabama
- West: Nevada, Arizona, Oregon, Idaho, Alaska
- East: Maine, Vermont, Michigan
Population to Providers Ratio by State¶
Let's find out the ratio of population to mental healthcare providers to understand which states have the least number of providers.
Dataframe for Mental Healthcare providers by state¶
We will use provider_data_layer to subset mental healthcare providers
In [48]:
# Get provider data for mental healthcare providers only
mental_df = provider_data_layer.query(where="user_taxonomy_code_1 in ('2084P0800X','207QG0300X','273R00000X','103T00000X','103TA0400X','103TA0700X','103TC0700X','103TC2200X','103TB0200X','103TC1900X','103TE1000X','103TE1100X','103TF0000X','103TF0200X','103TP2701X','103TH0004X','103TH0100X','103TM1700X','103TM1800X','103TP0016X','103TP0814X','103TP2700X','103TR0400X','103TS0200X','103TW0100X','106E00000X','106S00000X','2084A0401X','2084P0802X','2084B0002X','2084P0804X','2084N0600X','2084D0003X','2084F0202X','2084P0805X','2084H0002X','2084P0005X','2084N0400X','2084N0402X','2084N0008X','2084P2900X','2084P0015X','2084S0012X','2084S0010X','2084V0102X','364SP0808X','364SP0809X','364SP0807X','364SP0810X','364SP0811X','364SP0812X','364SP0813X','283Q00000X','261QM0801X')",
out_fields='user_npi,user_entity_type,user_provider_gender,user_taxonomy_code_1,user_full_address,postal,city,subregion,region,regionabbr', as_df=True)
# mental_df = mental_featureset.sdf
mental_df.head()
Out[48]:
In [62]:
# Create a csv
mental_df.to_csv(r'C:\Users\mohi9282\Desktop\arcgis\DATAFRAMES\allMentalProviders_df.csv', index=None, header=True)
In [12]:
# # Read from csv
# mental_df = pd.read_csv(r'C:\Users\mohi9282\Desktop\arcgis\DATAFRAMES\allMentalProviders_df.csv', low_memory=False)
# mental_df.head()
Out[12]:
In [13]:
# Create dataframe of mental healthcare provider counts by state
mental_count_df = pd.DataFrame(mental_df['regionabbr'].value_counts().reset_index().values, columns=['regionabbr','Provider_Count'])
In [14]:
# Plot mental healthcare Providers by State
plt.figure(figsize=(25,12))
sns.barplot(mental_count_df['regionabbr'].iloc[:-19], mental_count_df['Provider_Count'].iloc[:-19])
plt.title('Mental Healthcare Providers by State', fontsize=22)
plt.xlabel('States', fontsize=18)
plt.ylabel('Provider Count', fontsize=18)
Out[14]:
Dataframe for Population by State¶
We will use the population density layer at state level to create this dataframe
In [15]:
# State population dataframe
state_layer = popdensity.layers[43]
state_df = state_layer.query(out_fields='STATE_NAME,ST_ABBREV,TOTPOP_CY', as_df=True)
# state_df = state_featureset.sdf
state_df.head()
Out[15]:
Merge Provider Count and Population Dataframes¶
In [16]:
# Merge provider count and population at state level
# Merge with State data on left to preserve 'polygon' geometry
state_mental_df = pd.merge(state_df,mental_count_df,right_on='regionabbr', left_on='ST_ABBREV',how='inner')
In [17]:
state_mental_df.head()
Out[17]:
In [18]:
# Create new columns that shows people per provider
state_mental_df['people_per_prov'] = state_mental_df['TOTPOP_CY']/state_mental_df['Provider_Count']
In [19]:
# Arrange dataframe by people_per_prov descending
state_mental_df = state_mental_df.sort_values(by=['people_per_prov'], ascending=False)
state_mental_df.head()
Out[19]:
In [81]:
# Write df to csv
state_mental_df.to_csv(r'C:\Users\mohi9282\Desktop\arcgis\DATAFRAMES\MentalProviders_StateLevel_df.csv', index=None, header=True)
In [21]:
# # Read csv
# # Read from csv
# state_mental_df = pd.read_csv(r'C:\Users\mohi9282\Desktop\arcgis\DATAFRAMES\MentalProviders_StateLevel_df.csv', low_memory=False)
# state_mental_df.head()
In [20]:
state_mental_df.spatial.geometry_type
Out[20]:
Plot Shortage¶
In [22]:
mental_shortage_map = gis.map('USA', zoomlevel=4)
mental_shortage_map
Define Renderer¶
In [23]:
# Define Renderer
esriTest = {"renderer": { #This tells python to use JS autocasting
"type": "classBreaks",
"field":"people_per_prov",
"transparency":.5,
"minValue":1}}
In [24]:
# Define Manual Class breaks
esriTest['renderer']["classBreakInfos"] = [{
"classMaxValue": 1000.00,
"label": "0 - 1000.00",
"description": "0 - 1000.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [255,247,236,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 1500.00,
"label": "1000.001 - 1500.00",
"description": "1000.001 - 1500.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [253,220,174,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 2000.00,
"label": "1500.001 - 2000.00",
"description": "1500.001 - 2000.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [252,177,123,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 2500.00,
"label": "2000.001 - 2500.00",
"description": "2000.001 - 2500.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [241,109,75,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 3000.00,
"label": "2500.001 - 3000.00",
"description": "2500.001 - 3000.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [200,28,18,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}]
Plot Map¶
In [25]:
# Plot Map using defined Renderer
mental_shortage_map.remove_layers()
state_mental_df.spatial.plot(map_widget=mental_shortage_map, renderer=esriTest['renderer'])
Out[25]:
In [135]:
#### FOR AUTOMATIC RENDERING - manual class breaks are not used
# state_mental_df.spatial.plot(map_widget=mental_shortage_map,
# renderer_type='c', # for class breaks renderer
# method='esriClassifyNaturalBreaks', # classification algorithm
# class_count=6, # choose the number of classes
# col='people_per_prov', # numeric column to classify
# cmap='OrRd', # color map to pick colors from for each class
# alpha=0.7) # specify opacity
Out[135]:
In [26]:
# Add Legend
mental_shortage_map.legend=True
In [199]:
mental_shortage_map.remove_layers()
Out[199]:
In [146]:
mental_shortage_map.take_screenshot()
From this map we can see that, Mississippi is the worst with highest no. of people per mental healthcare provider followed by Alabama, Idaho, Texas, Arkansas and Iowa.
Plot Population per Mental Healthcare Provider¶
In [20]:
# Plot No. of People per Mental Heathcare Provider by State
plt.figure(figsize=(25,12))
sns.barplot(state_mental_df['regionabbr'], state_mental_df['people_per_prov'])
plt.title('No. of People per Mental Heathcare Provider by State', fontsize=22)
plt.xlabel('States', fontsize=18)
plt.ylabel('No. of People', fontsize=18)
plt.xticks(fontsize=15)
plt.yticks(fontsize=15)
Out[20]:
On average, there were ~2754 people per mental healthcare provider in Mississippi compared to ~364 people per provider in DC. The difference is drastic.
Exploring Mississippi¶
Mississippi has the highest number of people per mental healthcare provider. Let's explore Mississippi to find out which counties have the lowest number of providers.
Dataframe for Population in Mississippi¶
In [27]:
# County population df
county_layer = popdensity.layers[46]
MS_pop_df = county_layer.query(where="ST_ABBREV='MS'", out_fields='ST_ABBREV,NAME,TOTPOP_CY', as_df=True)
# MS_pop_df = MS_featureset.sdf
MS_pop_df.head()
Out[27]:
Dataframe for Mental Healthcare Providers in Mississippi by County¶
In [28]:
# Get provider data for obgyn providers only
mental_MS_df = mental_df[mental_df['regionabbr']=='MS']
mental_MS_df.head()
mental_MS_df.shape
Out[28]:
In [29]:
# Create dataframe of provider counts by county
mental_MScounty_df = pd.DataFrame(mental_MS_df['subregion'].value_counts().reset_index().values, columns=['County','Provider_Count'])
mental_MScounty_df.head()
Out[29]:
Merge Provider Count and Population Dataframes for MS¶
In [30]:
# Merge provider count and women data at county level for ND
county_mental_df = pd.merge(MS_pop_df,mental_MScounty_df,left_on='NAME', right_on='County',how='left')
In [31]:
county_mental_df.head()
Out[31]:
In [32]:
# Look at null values
county_mental_df[county_mental_df['Provider_Count'].isnull()]
Out[32]:
We can see that,
- 18 counties in Mississippi do not have any mental healthcare provider.
We will replace NaN values for Provider Count in these counties with 1 to plot them on the map to see which counties have highest number of people per provider.
In [33]:
county_mental_df['Provider_Count'].replace(np.nan,1,inplace=True)
In [34]:
# Create new columns that shows Mental Healthcare provider by population
county_mental_df['people_per_prov'] = county_mental_df['TOTPOP_CY']/county_mental_df['Provider_Count']
Plot Shortage¶
In [37]:
mental_countyshortage_map = gis.map('Mississippi, USA', zoomlevel=6)
mental_countyshortage_map
Define Renderer¶
In [38]:
# Define Renderer
mentalCountyTest = {"renderer": { #This tells python to use JS autocasting
"type": "classBreaks",
"field":"people_per_prov",
"transparency":.5,
"minValue":1}}
In [39]:
# Define Manual Class breaks
mentalCountyTest['renderer']["classBreakInfos"] = [{
"classMaxValue": 7500.00,
"label": "0 - 7500.00",
"description": "0 - 7500.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [255,247,236,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 15000.00,
"label": "7500.001 - 15000.00",
"description": "7500.001 - 15000.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [253,220,174,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 22500.00,
"label": "15000.001 - 22500.00",
"description": "15000.001 - 22500.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [252,177,123,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 30000.00,
"label": "22500.001 - 30000.00",
"description": "22500.001 - 30000.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [241,109,75,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 37500.00,
"label": "30000.001 - 37500.00",
"description": "30000.001 - 37500.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [200,28,18,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}]
Plot Map¶
In [40]:
# Plot Map using defined Renderer
mental_countyshortage_map.remove_layers()
county_mental_df.spatial.plot(map_widget=mental_countyshortage_map, renderer=mentalCountyTest['renderer'])
Out[40]:
In [150]:
#### FOR AUTOMATIC RENDERING - manual class breaks are not used
# county_mental_df.spatial.plot(map_widget=mental_countyshortage_map,
# renderer_type='c', # for class breaks renderer
# method='esriClassifyNaturalBreaks', # classification algorithm
# class_count=5, # choose the number of classes
# col='people_per_prov', # numeric column to classify
# cmap='OrRd', # color map to pick colors from for each class
# alpha=0.7 , # specify opacity
# )
Out[150]:
In [41]:
mental_countyshortage_map.legend = True
In [204]:
mental_countyshortage_map.remove_layers()
Out[204]:
In [42]:
test = county_mental_df.sort_values(by='people_per_prov', ascending=False)[['NAME','TOTPOP_CY','Provider_Count','people_per_prov']]
test.head()
Out[42]:
In [156]:
# Take Screenshot
mental_countyshortage_map.take_screenshot()
We can see that,
- Marshall County seems to be the worst with 1 provider for 37137 people. Some other counties with high population per provider are Pontotoc, Neshoba, Scott and Union.
To summarize, Mississippi has the highest number of people per Mental Healthcare Provider
- There were ~2754 people per mental healthcare provider in Mississippi compared to ~364 people per provider in DC
- 18 counties in Mississippi do not have any mental healthcare provider
- Marshall County seems to be the worst with 1 provider for 37137 people. Some other counties with high population per provider are Pontotoc, Neshoba, Scott and UnionWomen's Health¶
Image source: https://www.aamc.org/news-insights/labor-pains-ob-gyn-shortage
- Half of U.S. counties lack a single OB-GYN and women’s lives are endangered by long treks for much-needed care.
- With a severe shortage of obstetrician/gynecologists forecasted, some metropolitan areas are prone to crisis-level conditions.
- By 2020, there will be a shortage of up to 8,800 OB-GYNs, and the shortage may grow upto 22,000 by 2050.
Let's explore the distribution of OBGYN health providers in US using a heatmap.
Note - Provider Taxonomy codes were filtered for OB-GYN providers using this reference.
OBGYN Providers - Heat Map¶
In [29]:
# Create Map
women_map = gis.map('USA', 4)
women_map
In [30]:
# Define renderer and add provider data for OBGYN providers
renderer = {"renderer": "autocast", #This tells python to use JS autocasting
"type": "heatmap",
"blurRadius":1, # changes the size of the clusters
"maxPixelIntensity":2,
"minPixelIntensity":0,
"field":None}
renderer["colorStops"] = [{"ratio":0,"color":[63, 40, 102, 0]},
{"ratio":0.25,"color":[167,97,170,179]},
{"ratio":0.50,"color":"#7b3ce9"},
{"ratio":0.75,"color":[222,102,0,179]},
{"ratio":1,"color":[244,204,0,179]}]
women_map.add_layer(provider_data_layer,
{ "type": "FeatureLayer",
"renderer": renderer,
"definition_expression" : "user_taxonomy_code_1 in ('207V00000X','207VC0200X','207VF0040X','207VX0201X','207VG0400X','207VH0002X','207VM0101X','207VB0002X','207VX0000X','207VE0102X','363LX0001X','163WR1000X','163WW0101X','282NW0100X')"
# "definition_expression" : "user_taxonomy_code_1 = '207VC0200X' or user_taxonomy_code_1 = '207V00000X'"
})
In [31]:
# Remove Layer
women_map.remove_layers()
Out[31]:
In [22]:
# Take Screenshot
women_map.take_screenshot()
This map paints a grim picture of the availability of OBGYN healthcare providers. We can see vast areas in Midwest and West with NO or very few OBGYN providers.
Mothers to Providers Ratio by State¶
In this section our goal is to identify which states have the highest mother's to providers ratio. Let's get data from the American Community Survey (ACS) about fertility in past 12 months by age of mother using ACS_Fertility_by_Age_Boundaries layer at State, County and Tract level. We will merge OBGYN providers data with Fertility data to achieve this.
Get the layers¶
In [43]:
# Get the Fertility Layers
fertility_search = gis.content.search('title: ACS_Fertility_by_Age_Boundaries', 'Feature Layer')
fertility_item = fertility_search[0]
fertility_item.layers
Out[43]:
In [44]:
# Define layers for State, County and Tract (Percent of women 15 to 50 who had a birth in the past 12 months)
fertility_state = fertility_item.layers[0]
fertility_county = fertility_item.layers[1]
fertility_tract = fertility_item.layers[2]
Dataframe for women population by State¶
We will use the fertility layer at state level to create this dataframe
In [45]:
# State population dataframe
fertility_featureset = fertility_state.query(where="B13016_001E>1")
fertility_df = fertility_featureset.sdf
fertility_df.head()
Out[45]:
Dataframe for OB-GYN providers by state¶
We will use provider_data_layer to subset OB-GYN providers
In [46]:
# Get provider data for obgyn providers only
obgyn_df = provider_data_layer.query(where="user_taxonomy_code_1 in ('207V00000X','207VC0200X','207VF0040X','207VX0201X','207VG0400X','207VH0002X','207VM0101X','207VB0002X','207VX0000X','207VE0102X','363LX0001X','163WR1000X','163WW0101X','282NW0100X')", out_fields='user_npi,user_entity_type,user_provider_gender,user_taxonomy_code_1,user_full_address,postal,city,subregion,region,regionabbr', as_df=True)
# obgyn_df = obgyn_featureset.sdf
obgyn_df.head()
Out[46]:
In [47]:
# Create a csv
# obgyn_df.to_csv(r'C:\Users\mohi9282\Desktop\arcgis\DATAFRAMES\allObgynProviders_df.csv', index=None, header=True)
In [48]:
# Create dataframe of obgyn provider counts by state
obgyn_count_df = pd.DataFrame(obgyn_df['regionabbr'].value_counts().reset_index().values, columns=['regionabbr','Provider_Count'])
In [49]:
# Plot OB-GYN Providers by State
plt.figure(figsize=(25,12))
sns.barplot(obgyn_count_df['regionabbr'].iloc[:-8], obgyn_count_df['Provider_Count'].iloc[:-8])
plt.title('OB-GYN Providers by State', fontsize=22)
plt.xlabel('States', fontsize=18)
plt.ylabel('Provider Count', fontsize=18)
Out[49]:
Merge Provider Count and Population Dataframes¶
In [50]:
# Merge provider count and women_df at state level
state_obgyn_df = pd.merge(fertility_df,obgyn_count_df,right_on='regionabbr', left_on='STUSPS',how='inner')
In [51]:
# Create new columns that shows provider by women pop
state_obgyn_df['women_per_prov'] = state_obgyn_df['B13016_001E']/state_obgyn_df['Provider_Count']
# Create new columns that shows provider by mother pop
state_obgyn_df['mother_per_prov'] = state_obgyn_df['B13016_002E']/state_obgyn_df['Provider_Count']
In [52]:
# Arrange dataframe by mother_per_prov descending
state_obgyn_df = state_obgyn_df.sort_values(by=['mother_per_prov'], ascending=False)
In [53]:
state_obgyn_df = state_obgyn_df.loc[:,['OBJECTID','SHAPE','regionabbr','Provider_Count','women_per_prov','mother_per_prov']]
state_obgyn_df.head()
Out[53]:
In [54]:
# Write df to csv
# state_obgyn_df.to_csv(r'C:\Users\mohi9282\Desktop\arcgis\DATAFRAMES\ObgynProviders_StateLevel_df.csv', index=None, header=True)
In [55]:
state_obgyn_df.spatial.geometry_type
Out[55]:
Plot Shortage¶
In [56]:
obgyn_shortage_map = gis.map('USA', zoomlevel=4)
obgyn_shortage_map
Define Renderer¶
In [57]:
# Define Renderer
stateObgynTest = {"renderer": { #This tells python to use JS autocasting
"type": "classBreaks",
"field":"mother_per_prov",
"transparency":.5,
"minValue":1}}
In [58]:
# Define Manual Class breaks
stateObgynTest['renderer']["classBreakInfos"] = [{
"classMaxValue": 23.00,
"label": "0 - 23.00",
"description": "0 - 23.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [255,247,236,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 46.00,
"label": "23.001 - 46.00",
"description": "23.001 - 46.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [253,220,174,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 69.00,
"label": "46.001 - 69.00",
"description": "46.001 - 69.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [252,177,123,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 92.00,
"label": "69.001 - 92.00",
"description": "69.001 - 92.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [241,109,75,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 115.00,
"label": "92.001 - 115.00",
"description": "92.001 - 115.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [200,28,18,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}]
Plot Map¶
In [59]:
# Plot Map using defined Renderer
obgyn_shortage_map.remove_layers()
state_obgyn_df.spatial.plot(map_widget=obgyn_shortage_map, renderer=stateObgynTest['renderer'])
Out[59]:
In [171]:
#### FOR AUTOMATIC RENDERING - manual class breaks are not used
# state_obgyn_df.spatial.plot(map_widget=obgyn_shortage_map,
# renderer_type='c', # for class breaks renderer
# method='esriClassifyNaturalBreaks', # classification algorithm
# class_count=5, # choose the number of classes
# col='mother_per_prov', # numeric column to classify
# cmap='OrRd', # color map to pick colors from for each class
# alpha=0.7 , # specify opacity
# )
Out[171]:
In [60]:
obgyn_shortage_map.legend=True
In [205]:
obgyn_shortage_map.remove_layers()
Out[205]:
In [61]:
obgyn_shortage_map.take_screenshot()
From this map, we can see that number of women (15 to 50) who had a birth in the past 12 months per OBGYN provider is high in Utah, North Dakota, South Dakota and Arkansas.
| State | Mo. of Mothers per OBGYN provider |
|---|---|
| ND | 112 |
| UT | 100 |
| AR | 93 |
| SD | 93 |
| ID | 92 |
Plot Mothers per OBGYN Provider¶
In [62]:
# Plot No. of Mothers (age 15 to 50) per OB-GYN Provider by State
plt.figure(figsize=(25,12))
sns.barplot(state_obgyn_df['regionabbr'], state_obgyn_df['mother_per_prov'])
plt.title('No. of Mothers (age 15 to 50) per OB-GYN Provider by State', fontsize=22)
plt.xlabel('States', fontsize=18)
plt.ylabel('No. of Mothers (age 15 to 50)', fontsize=18)
plt.xticks(fontsize=15)
plt.yticks(fontsize=15)
Out[62]:
On average, there were ~112 mothers and 1655 women per provider in ND compared to ~31 mothers and 662 women per provider in DC. The difference is drastic.
Exploring North Dakota¶
North Dakota has the highest number of mothers and women per OB-GYN provider. From the fertility map above, we also saw that percent of women (15 to 50) who had a birth in the past 12 months is high in North Dakota.
Let's explore North Dakota to find out which counties have the lowest number of OBGYN providers.
Dataframe for women population in North Dakota¶
In [63]:
# State population df
ND_fertility_df = fertility_county.query(where="STATE='North Dakota'", as_df=True)
# ND_fertility_df = ND_featureset.sdf
ND_fertility_df.head()
Out[63]:
Dataframe for OB-GYN providers in North Dakota by County¶
In [64]:
obgyn_ND_df = obgyn_df[obgyn_df['regionabbr']=='ND']
obgyn_ND_df.head()
Out[64]:
In [65]:
obgyn_ND_df.shape
Out[65]:
In [66]:
# Create dataframe of obgyn provider counts by county
obgyn_NDcounty_df = pd.DataFrame(obgyn_ND_df['subregion'].value_counts().reset_index().values, columns=['County','Provider_Count'])
obgyn_NDcounty_df.head()
Out[66]:
Merge Provider Count and Population Dataframes¶
In [67]:
# Merge provider count and women data at county level for ND
county_obgyn_df = pd.merge(ND_fertility_df,obgyn_NDcounty_df,left_on='NAME', right_on='County',how='left')
In [70]:
# Look at null values
county_obgyn_df[county_obgyn_df['Provider_Count'].isnull()][['NAME','Provider_Count']]
Out[70]:
We can see that:
- 43 out of 53 counties in ND do not have any Obgyn healthcare providers.
We will replace NaN values for Provider Count in these counties with 1 to plot them on the map to see which counties have highest number of mothers per provider.
In [71]:
# Replace NaN with 1
county_obgyn_df['Provider_Count'].replace(np.nan,1,inplace=True)
In [72]:
# Create new columns that shows provider by women pop
county_obgyn_df['women_per_prov'] = county_obgyn_df['B13016_001E']/county_obgyn_df['Provider_Count']
# Create new columns that shows provider by mother pop
county_obgyn_df['mother_per_prov'] = county_obgyn_df['B13016_002E']/county_obgyn_df['Provider_Count']
In [73]:
# Arrange dataframe by mother_per_prov descending and then B13016_002E (women who gave birht) descending
county_obgyn_df = county_obgyn_df.sort_values(by=['mother_per_prov','B13016_002E'], ascending=False)[['OBJECTID','SHAPE','NAME','Provider_Count','B13016_001E','B13016_002E','women_per_prov','mother_per_prov']]
county_obgyn_df.columns = ['OBJECTID','SHAPE','Name','Provider_Count', "Total Women (15 to 50)","Women who had birth (past 12 months)", 'women_per_prov', 'mother_per_prov']
county_obgyn_df.head()
Out[73]:
Plot Shortage¶
In [75]:
obgyn_countyshortage_map = gis.map('North Dakota, USA', zoomlevel=6)
obgyn_countyshortage_map
Define Renderer¶
In [76]:
# Define Renderer
obgynCountyTest = {"renderer": { #This tells python to use JS autocasting
"type": "classBreaks",
"field":"mother_per_prov",
"transparency":.5,
"minValue":1}}
In [77]:
# Define Manual Class breaks
obgynCountyTest['renderer']["classBreakInfos"] = [{
"classMaxValue": 100.00,
"label": "0 - 100.00",
"description": "0 - 100.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [255,247,236,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 200.00,
"label": "100.001 - 200.00",
"description": "100.001 - 200.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [253,220,174,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 300.00,
"label": "200.001 - 300.00",
"description": "200.001 - 300.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [252,177,123,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 400.00,
"label": "300.001 - 400.00",
"description": "300.001 - 400.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [241,109,75,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}, {
"classMaxValue": 500.00,
"label": "400.001 - 500.00",
"description": "400.001 - 500.00",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [200,28,18,178.5],
"outline": {
"style": "esriSLSSolid",
"type": "esriSLS",
"color": [128,128,128,255],
"width": 2
}
}
}]
Plot Map¶
In [78]:
# Plot Map using defined Renderer
obgyn_countyshortage_map.remove_layers()
county_obgyn_df.spatial.plot(map_widget=obgyn_countyshortage_map, renderer=obgynCountyTest['renderer'])
Out[78]:
In [192]:
#### FOR AUTOMATIC RENDERING - manual class breaks are not used
# county_obgyn_df.spatial.plot(map_widget=obgyn_countyshortage_map,
# renderer_type='c', # for class breaks renderer
# method='esriClassifyNaturalBreaks', # classification algorithm
# class_count=5, # choose the number of classes
# col='mother_per_prov', # numeric column to classify
# cmap='OrRd', # color map to pick colors from for each class
# alpha=0.7 , # specify opacity
# )
Out[192]:
In [79]:
obgyn_countyshortage_map.legend=True
In [206]:
obgyn_countyshortage_map.remove_layers()
Out[206]:
In [80]:
obgyn_countyshortage_map.take_screenshot()
We can see that:
- Morton County seems to be the worst with 463 women who gave birth but no provider.
North Dakota has the highest number of women (15 to 50) who had a birth in the past 12 months per OBGYN provider.
- There were ~112 mothers and 1655 women per provider in ND compared to ~31 mothers and 662 women per provider in DC
- 43 out of 53 counties in ND do not have any OBGYN healthcare provider
- Morton County seems to be the worst with 463 women who gave birth but no providerSummary¶
To summarize, we explored the shortage of Mental Health and OBGYN Providers accross United States. We saw that:
- Mississippi has the highest number of people per Mental Healthcare Provider
- There were ~2754 people per mental healthcare provider in Mississippi compared to ~364 people per provider in DC.
- 18 counties in Mississippi do not have any mental healthcare provider.
- Marshall County seems to be the worst with 1 provider for 37137 people. Some other counties with high population per provider are Pontotoc, Neshoba, Scott and Union.
- North Dakota has the highest number of women (15 to 50) who had a birth in the past 12 months per OBGYN provider.
- There were ~112 mothers and 1655 women per provider in ND compared to ~31 mothers and 662 women per provider in DC.
- 43 out of 53 counties in ND do not have any OBGYN healthcare provider.
- Morton County seems to be the worst with 463 women who gave birth but no provider.